package com.dnjn.happiness.emo.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.dnjn.happiness.emo.domain.Ranklist;
import com.dnjn.happiness.emo.domain.vo.RanklistVO;
import org.apache.ibatis.annotations.ResultType;
import org.apache.ibatis.annotations.Select;

/**
 * 每日打卡榜单ranklistMapper接口
 * 
 * @author amber
 * @date 2024-03-05
 */
public interface RanklistMapper extends  BaseMapper<Ranklist>
{

    @ResultType(RanklistVO.class)
    @Select("select po.*,u.sex,u.avatar,u.empno from emo_ranklist po left join sys_user u on u.user_id =po.user_id")
    Page<RanklistVO> selectPageX(Page page);
}
